<?php
$sql = "
select 
		OBJECT_NAME										as NAME, 
		TO_CHAR(LAST_DDL_TIME, 'YYYY-MM-DD HH24:MI:SS') as CREATE_DATE, 
		'{$param['schema']}'					as DBOWNER 
from 
		user_objects 
where 
		object_type = 'PROCEDURE'  
order by 
		object_name 
";

return $sql;

?>